 
select 'BuildVersion' as TableName, count(*) as RecordCount from BuildVersion 
 union select 'ErrorLog' as TableName, count(*) as RecordCount from ErrorLog 
 union select 'SalesLT.Address' as TableName, count(*) as RecordCount from SalesLT.Address 
 union select 'SalesLT.Customer' as TableName, count(*) as RecordCount from SalesLT.Customer 
 union select 'SalesLT.CustomerAddress' as TableName, count(*) as RecordCount from SalesLT.CustomerAddress 
 union select 'SalesLT.Product' as TableName, count(*) as RecordCount from SalesLT.Product 
 union select 'SalesLT.ProductCategory' as TableName, count(*) as RecordCount from SalesLT.ProductCategory 
 union select 'SalesLT.ProductDescription' as TableName, count(*) as RecordCount from SalesLT.ProductDescription 
 union select 'SalesLT.ProductModel' as TableName, count(*) as RecordCount from SalesLT.ProductModel 
 union select 'SalesLT.ProductModelProductDescription' as TableName, count(*) as RecordCount from SalesLT.ProductModelProductDescription 
 union select 'SalesLT.SalesOrderDetail' as TableName, count(*) as RecordCount from SalesLT.SalesOrderDetail 
 union selec 'SalesLT.SalesOrderHeader' as TableName, count(*) as RecordCount from SalesLT.SalesOrderHeader 

